StockMeter

Entity Definition

Logical Name : StockMeter
Physical Name : AS_MTR_STK

A mechanical or electronic meter that counts the monetary value or volume of unblended BULK ITEM dispensed during all FUELLING TRANSACTIONS ever.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer RetailStore(PA_STR_RTL)
StockMeterID (PK) A unique identifier for the stock meter ID_MTR_STK Identity integer
UnitOfMeasureCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM Code varchar(20) UnitOfMeasure(CO_UOM)
DeviceMeterID The MeterID the FuelingPoint uses to identify this StockMeter. Cannot use this MeterID as the Primary Key because Meters break and need to be replaced. ID_MTR_DVC IdentityAlphaNumeric varchar(20)
StatusCode A code denoting the status of the StockMeter. Possible values include Active and InActive. SC_MTR Code2Status char(2)

Relationships

Parent Entity Verb Phrase Child Entity
UnitOfMeasure counts StockMeter
RetailStore has StockMeter
StockMeter records Blender
StockMeter records StockMeterReading

Logical Views containing StockMeter

Logical View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20040 - Forecourt History View